The following tables describe how the UCAS column details are mapped onto ebs Tables/Columns:
Where more than one field is listed, it is the first one in the list that is populated, unless otherwise stated.
UCAS Applicant Details (UCAS_APPLICANT_DETAILS)
| UCAS Column |
ebs Table/Column |
Notes |
|
Surname
|
People.surname |
|
| DateofBirth |
People.date_of_birth |
Set to blank if outside institution defined boundaries |
| Firstname |
People.forename and
People.middle_names |
Updated in 4.44 to split into forename and middle names |
| Title |
People.title |
Verifier lookup on Title
|
| Gender |
People.sex |
Verifier Lookup on Sex
|
| NationalInsuranceNumber |
People.ni_number |
|
| MobilePhoneNo |
People.mobile_phone_number |
|
| NominatedName |
People.fes_next_of_kin |
|
| NominatedRelationship |
People.fes_nok_cont_rel |
|
| DateEnteredUk |
People.date_uk_entry |
Added in 4.45 |
| EmailAddress |
People.personal_email |
|
| countryOfBirthCode |
People.place_of_birth |
Verifier code lookup on Nationality
|
| preferredFirstname |
People.known_as or People.preferred_first_name |
Added in 4.45 |
| uniqueLearnerNumber |
People.unique_learn_no |
|
| personalID |
People_ilr.ucasperid |
|
| nationalityCode |
People.Nationality |
Verifier code lookup on Nationality (added in 4.44) |
| |
Addresses.addess_type |
Institution setting – “UCAS HE ebs Address Type” |
| |
Addresses.start_date |
Import Date |
| |
Addresses.owner_type |
Hard coded to “P” |
| Address1 |
Addresses.address_line_1 |
|
| Address2 |
Addresses.address_line_2 |
|
| Address3 |
Addresses.address_line_3 |
|
| Address4 |
Addresses.address_line_4 |
|
| Postcode |
Addresses.uk_post_code_pt1 and a.uk_postcode_pt2 |
|
UCAS Applicant Qualifications (UCAS_APPLICANT_QUALIFICATIONS)
| UCAS Column |
ebs Table/Column |
Notes |
| |
Attainments.atype_attainment_type_code |
Institution setting – “UCAS HE Qualification on Entry code” |
| subjectOrCourse |
Attainments.description |
Attainment description is “levelcode – subjectOrCourse” |
| levelCode |
Attainments.description |
| entrydateyear |
Attainments.fes_year_achieved |
If resultorclass is populated. Defaults to current year if not set |
| resultOrClass |
Attainments.grade |
|
| predictedGrades |
Attainments.fes_predicted_grade |
|
UCAS Applicant Choices (UCAS_APPLICANT_CHOICES)
| UCAS Column |
ebs Table/Columns |
Notes |
| |
People_units.unit_type |
Hardcoded to “A” |
| |
People_units.progress_code |
Institution setting -“Default application progress code” |
| |
People_units.progress_date |
Import date |
| |
People_units.who_to_pay |
Institution setting, Applications “Who to pay” |
| |
People_units.record_date |
Import date |
| courseCode |
|
Used to find matching ebs UIO. PointOfEntry Included in matching from 4.46. |
| yearOfEntry |
|
| pointOfEntry |
|
| campus |
|
Optionally used for course matching based on institution setting and reference data. |
| criminalRecordDeclaration |
|
Used to indicate whether an applicant has declared a criminal record. |
UCAS Applicant Background (UCAS_APPLICANT_BACKGROUND)
| UCAS Column |
ebs Table/Columns |
Notes |
| ethnicCode |
People.Ethnicity |
Verifier code lookup on Ethnicity (added in 4.44). |
UCAS Applicant Living with Conditions (UCAS_APP_LIVING_WITH CONDITION)
| UCAS Column |
ebs Table/Columns |
Notes |
|
Code
|
Disabilities.Disability_type
|
Verifier Lookup on Disabilities (Added in 4.48)
|
|
AdditionalNeeds
|
Notes.Notes
|
Note linked to the Disability record
|
|
|
Disabilities.Long_Description
|
Set as “See Notes for further information” if AdditionalNeeds is populated
|
|
LastUpdated
|
Disabilities.Start_date
|
|